<?php
/**
 * Created by PhpStorm.
 * User: hooshim
 * Date: 2014-12-03
 * Time: 오전 11:23
 */

header("Content-Type:text/html;charset=utf-8");
header("Cache-Control:no-cache");
header("Pragma:no-cache");

include_once ($_SERVER['DOCUMENT_ROOT']."/inc/conn.inc.php");
include_once ($_SERVER['DOCUMENT_ROOT']."/inc/function.inc.php"); ##property 파일 인크루드됨.

//## 파라미터 선언
$payCd 			= $_POST['payCd'];
$paySeq 		= $_POST['paySeq'];

// Table 이름 선언
$tbname = "tblPayment";

$curDt =date("Y-m-d");

$query = "SELECT A.payCd, A.compCd, A.article, A.planDt, A.billCd ";
$query .= ", REPLACE(CONVERT(varchar, CAST(A.amount AS money), 1), '.00', '') amount ";
$query .= ", REPLACE(CONVERT(varchar, CAST(A.orgAmount AS money), 1), '.00', '') orgAmount ";
$query .= ", REPLACE(CONVERT(varchar, CAST(A.tax AS money), 1), '.00', '') tax ";
$query .= ", A.flag";
$query .= " FROM {$tbname} A WHERE payCd='{$payCd}'";
$query = iconvEncode($query);

$logger->debug($query ."<br>[#FROM:" . $G_remote_ip."#]"); ## 쿼리 로그 작성
$result = makeJSONArray($query,$tbname);

if ($paySeq) {
    $query = "SELECT REPLACE(CONVERT(varchar, CAST(B.amount AS money), 1), '.00', '') payAmount";
    $query .= ", B.paySeq, B.actionDt, B.bankDt, B.memo payMemo, B.flag payFlag";
    $query .= " FROM tblPayResult B WHERE paySeq={$paySeq}";
    $query = iconvEncode($query);
    $incResult = makeJSONArray($query,"tblPayResult");
    $result["PAYRESULT"] = $incResult;
}

$output = json_encode($result);
$output = urldecode($output);
$output = iconvDecode($output);
$output = str_replace("<br />", "", $output);
echo $output;
$logger->debug($compCd ."//" .$output ."<br>[#FROM:" . $G_remote_ip."#]"); ## 결과 로그 작성
?>